You can schedule events to automate the process of importing and exporting form data in .CSV format.
Import functionality is available for all configurable forms except those listed in the About Importing Form Data topic.
Import data is entered into a Microsoft® Excel spreadsheet supplied with MiVoice Business and saved as .CSV files for import. For details concerning the spreadsheet, including conditions on its use, refer to About the Import Spreadsheet.
Prior to scheduling an import event, complete the following tasks:
Obtain the Import Spreadsheet or Prepare your own spreadsheet file for import
Audit Trail Logs generated by scheduled imports record the username and IP address as "Unknown." This is because Scheduler activities run without initiating a System Administration Tool session.
Not all forms support the exporting of data and not all forms support all the export options. If options are not supported for a form, they will be disabled ("grayed out") in the export dialog window.
For security, passwords and PINs in exported forms (such as the User and Services Configuration form) are masked using asterisks in the export file.
For details concerning export conditions, see Exporting Form Data.
Exported files are saved to an external FTP or SFTP server (same as scheduled file transfers).
To schedule night service events, refer to the following procedures:
To create a CSV Import event:
Go to the Scheduler
form.
Use the screen tools (arrows and mini-calendar) to locate the day you wish to update.
Select the day and click Add Event.
Click the Event Parameters tab and complete the following fields:
Title: Type a title for the event. The title can contain up to 255 alphanumeric characters.
Start Date: Use the dialog box to select the Month, Day, and Year that the event is scheduled to start.
Time: Use the dialog box to select the Hour, AM/PM, and Minute that the event is scheduled to occur. Click Set to save your changes.
Repeats: Not applicable. Import events cannot repeat.
Click the Activity Parameters tab and complete the following fields:
Select Activity: Select File Import Application.
Click the file icon to open the Import Scheduler dialog box.
From the Import Scheduler dialog box, click Browse.
Navigate to the .csv
file and then click Next.
A Validating Data dialog appears.
Review the data listed in the Import Preview window. Ensure that the date is in the YYYY-MM-DD format. If no errors are detected, proceed to the next step. Otherwise, click Previous to return to the Import dialog box, revise the import file data, and begin the import process again.
Click Import.
After the import is stopped, click OK to return to the form.
When the import completes successfully, click Finish.
Click Submit
and then OK to save the
new event.
The new event is added to the event list.
To create a CSV Export event:
Access the Scheduler form.
Use the screen tools (arrows and mini-calendar) to locate the day you wish to update.
Select the day and click Add Event.
Click the Event Parameters tab and complete the following fields:
Title: Type a title for the event. The title can contain up to 255 alphanumeric characters.
Start Date: Use the dialog box to select the Month, Day, and Year that the event is scheduled to start.
Time: Use the dialog box to select the Hour, AM/PM, and Minute that the event is scheduled to occur. Click Set to save your changes.
Repeats: Specify how often you want the event to repeat - Once, Daily, Weekly, Monthly, Yearly, or Repeats Interval. If you select Daily, Weekly, Monthly, or Yearly, the dialog expands, enabling you to customize the repetition interval. If you select Repeats Interval, you can specify the number up minutes between repeat events (up to 1440 minutes, or 24 hours), and whether you would like the event to be repeated continuously or a fixed number of times.
Click the Activity Parameters tab and complete the following fields:
Select Activity: Select CSV File Export Application.
Click in the Form to Export box and start typing keywords from the form's name. From the displayed list, select the form that you want to export (e.g. License and Option Selection).
Enter a File
Name with no extension up to 22 characters. Use alphanumeric
characters (a-z, A-Z, 0-9) plus _ and - only. "CSVExport"
followed by the system name plus the date and time in 24-hour
format is automatically appended to the file name.
Example: COS_Opts_CSVExport_mn25_20150527083512.csv
Click Submit
and then OK to save the
new event.
The new event is added to the event list.
NOTE: To run the event outside the normal schedule, see Execute an Event Immediately.